create external table jms_ods.tab_stage_indicator_cfg
   (        id string comment 'id',
        indicator_item string comment '指标项显示的字段名',
        indicator_desc string comment '指标项描述',
        indicator_field string comment '指标code',
        dimension_type string comment '类型code',
        dimension_desc string comment '类型名称',
        weight int comment '权重',
        target_value int comment '目标值',
        base_value int comment '保底值',
        update_time TIMESTAMP comment '更新时间',
        create_time TIMESTAMP comment '创建时间',
        create_by string comment '创建人',
        modify_by string comment '更新人',
        status int  comment '指标状态 0启用 1不起用',
        is_delete int comment '是否删除 0是 1否'
   ) comment '驿站分层指标'
PARTITIONED BY (`dt` string COMMENT '时间分区(yyyy-MM-dd) ')
stored as parquet
LOCATION
  '/dw/hive/jms_ods.db/external/tab_stage_indicator_cfg';